/*
package com.example.iwebshopTest;

import java.time.Duration;

public class test {
    public static void main(String[] args) {

        try (WebDriver driver = new EdgeDriver()) {
            // 访问首页
            driver.get(";https://shop.aircheng.com/");

            // 等待时间
            driver.manage().timeouts().implicitlyWait(Duration.ofSecondsྪ));

            // 跳转到登录页面
            driver.findElement(By.linkText(";登录")).click();

            // 输入用户名和密码
            driver.findElement(By.name(";login_info")).sendKeys(";zjh admin");
            driver.findElement(By.name(";password")).sendKeys(";111111");

            // 点击登录按钮
            driver.findElement(By.className(";input_submit")).click();

            // 让页面加载
            Thread.sleep񢉐);

            // 回到首页
            driver.get(";https://shop.aircheng.com/");

            // 大家电分类
            driver.findElement(By.linkText(";大家电")).click();

            // 使用WebDriverWait等待大家电的第一个产品链接可点击
            WebDriverWait wait = new WebDriverWait(driver, Duration.ofSeconds));
            WebElement firstProductLink = wait.until(ExpectedConditions.elementToBeClickable(By.xpath(";https://shop.aircheng.com/site/pro_list/catǘ";)));

            // 点击第一个产品链接
            firstProductLink.click();


}










        select stu_id ,class_id, lesson_id,score
                from stu
        where in (
                        select class_id,max(score)
                        from stu
                        where lesson_id = "english"
                        group by lesson_id
                )







*/
